package com.windupurnomo.util;

public class TableGenerator {
	public static final String TASK = "CREATE TABLE IF NOT EXISTS "+D.table.TASK+"("+
		D.field_task.ID+" INTEGER PRIMARY KEY, "+
		D.field_task.TASK+" TEXT, "+
		D.field_task.DURATION+" INTEGER, "+
		D.field_task.PLACE+" INTEGER, "+
		D.field_task.RES_WATER+" INTEGER, "+
		D.field_task.RES_FOOD+" INTEGER, "+
		D.field_task.RES_PAPER+" INTEGER, " +
		D.field_task.CON_POWER+" INTEGER, "+
		D.field_task.CON_SOCIAL+" INTEGER, "+
		D.field_task.CON_FINANCE+" INTEGER, "+
		D.field_task.CON_EIQ+" INTEGER)";
	
	public static final String PLAYER = "CREATE TABLE IF NOT EXISTS "+D.table.PLAYER+"("+
		D.field_player.ID+" INTEGER PRIMARY KEY AUTOINCREMENT, "+
		D.field_player.NAME+" TEXT, "+
		D.field_player.SEX+" TEXT, "+
		D.field_task.RES_WATER+" INTEGER, "+
		D.field_task.RES_FOOD+" INTEGER, "+
		D.field_task.RES_PAPER+" INTEGER, " +
		D.field_task.CON_POWER+" INTEGER, "+
		D.field_task.CON_SOCIAL+" INTEGER, "+
		D.field_task.CON_FINANCE+" INTEGER, "+
		D.field_task.CON_EIQ+" INTEGER, "+
		D.field_player.SCORE+" INTEGER)";
	
	public static final String RESOURCE = "CREATE TABLE IF NOT EXISTS "+D.table.RESOURCE+"("+
		D.field_resource.ID+" INTEGER PRIMARY KEY AUTOINCREMENT, "+
		D.field_resource.RESOURCE+" TEXT);";
	
	public static final String CONDITION = "CREATE TABLE IF NOT EXISTS "+D.table.CONDITION+"("+
		D.field_condition.ID+" INTEGER PRIMARY KEY AUTOINCREMENT, "+
		D.field_condition.CONDITION+" TEXT);";
	
	public static final String DAY = "CREATE TABLE IF NOT EXISTS "+D.table.DAY+"("+
		D.field_day.ID+" INTEGER PRIMARY KEY, "+
		D.field_day.WEATHER+" INTEGER, "+
		D.field_day.START+" INTEGER, "+
		D.field_day.FINISH+" INTEGER);";
	
	public static final String GAME ="CREATE TABLE IF NOT EXISTS "+D.table.GAME+"("+
		D.field_game.ID+" INTEGER, "+
		D.field_game.DAY+" INTEGER);";
	
	public static final String PLAYER_RESOURCE = "CREATE TABLE IF NOT EXISTS "+D.table.PLAYER_RESOURCE+"("+
		D.field_player_res.ID_PLAYER+" INTEGER,"+
		D.field_player_res.ID_RESOURCE+" INTEGER);";
	
	public static final String PLAYER_CONDITION = "CREATE TABLE IF NOT EXISTS "+D.table.PLAYER_CONDITION+"("+
		D.field_player_cond.ID_CONDITION+" INTEGER,"+
		D.field_player_cond.ID_PLAYER+" INTEGER);";
	
	public static final String GAME_DAY = "CREATE TABLE IF NOT EXISTS "+D.table.GAME_DAY+"("+
		D.field_game_day.ID_GAME+" INTEGER,"+
		D.field_game_day.ID_DAY+" INTEGER,"+
		D.field_game_day.BONUS+" TEXT);";
	
	public static final String TASK_DAY = "CREATE TABLE IF NOT EXISTS "+D.table.TASK_DAY+"("+
		D.field_task_day.ID_DAY+" INTEGER, "+
		D.field_task_day.ID_TASK+" INTEGER, "+
		D.field_task_day.START+" INTEGER, "+
		D.field_task_day.FINISH+" INTEGER);";
	
	public static final String TASK_RESOURCE = "CREATE TABLE IF NOT EXISTS "+D.table.TASK_RESOURCE+"("+
		D.field_task_resource.ID_TASK+" INTEGER,"+
		D.field_task_resource.ID_RESOURCE+" INTEGER,"+
		D.field_task_resource.AMOUNT+" INTEGER);";
	
	public static final String TASK_CONDITION = "CREATE TABLE IF NOT EXISTS "+D.table.TASK_CONDITION+"("+
		D.field_task_condition.ID_TASK+" INTEGER,"+
		D.field_task_condition.ID_CONDITION+" INTEGER,"+
		D.field_task_resource.AMOUNT+" INTEGER);";
}
